package saxena.mf.utils;

import java.io.UnsupportedEncodingException;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
import java.sql.ResultSet;
import java.sql.SQLException;

import saxena.mf.db.mysql.QueryHelper;
import saxena.mf.user.User;

public class MFUtils {

	public static QueryHelper helper = null;
	static {
		init();
	}
	
	public static void init(){
		try {
			helper = QueryHelper.getHelper();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	private static String convertToHex(byte[] data) {
		StringBuffer buf = new StringBuffer();
		for (int i = 0; i < data.length; i++) {
			int halfbyte = (data[i] >>> 4) & 0x0F;
			int two_halfs = 0;
			do {
				if ((0 <= halfbyte) && (halfbyte <= 9))
					buf.append((char) ('0' + halfbyte));
				else
					buf.append((char) ('a' + (halfbyte - 10)));
				halfbyte = data[i] & 0x0F;
			} while (two_halfs++ < 1);
		}
		return buf.toString();
	}

	public static String SHA1(String text) throws NoSuchAlgorithmException,
			UnsupportedEncodingException {
		MessageDigest md;
		md = MessageDigest.getInstance("SHA-1");
		byte[] sha1hash = new byte[40];
		md.update(text.getBytes("iso-8859-1"), 0, text.length());
		sha1hash = md.digest();
		return convertToHex(sha1hash);
	}

	public static boolean chkUser(User user){
		try {
			ResultSet res = helper.executeQuery(MFQueries.GET_USER_FROM_UID, user.getUserID());
			if(!res.next())
				return false;
			String uname = res.getString(2);
			return uname.equals(user.getUserName());
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
	}
	public static void addUser(User user) throws Exception{
		int rowc = helper.executeUpdate(MFQueries.ADD_USER, user.getUserID(),user.getUserName());
		if(rowc != 1)
			throw new Exception("Some problem in adding user");
	}
}
